<?php

function ListCatnews()
{
  global $dbsql,$language;
  
  $sql_select   = "select * from tblcategory where cType='news' and iStatus=1 and iParentId>0 and cLanguage='$language'";
  return $dbsql->load($sql_select);  
}

function ListOptionProductCat()
{
    global $dbsql,$language;
    
    $sql_select = "select * from tblproduct_category where iStatus=1 and iParentId=0 and cLanguage='$language'";
    $rs         = $dbsql->query($sql_select);
    $options    = '';
    while($result   = $dbsql->fetch_array($rs))
    {
        $options    .= '<option value="'.$result['iId'].'">'.$result['cName'].'</option>';
    }
    return $options;
}

function ListPrice()
{
    $options    = '';
    
    for($i=1;$i<10;$i++)
    {
        $options    .= '<option value="'.$i.'">'.getPriceClient($i*100000).'</option>';
    }
    return $options;
}
?>